package com.cqjtu.eecs.mapper;

import com.cqjtu.eecs.entity.CourseGoalScore;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * 课程目标-成绩 Mapper 接口
 * </p>
 *
 * @author    
 * @since 2022-03-07
 */
public interface CourseGoalScoreMapper extends BaseMapper<CourseGoalScore> {


    /**
     * 获取某个自然班所有学生的某个课程目标对毕业要求的贡献值总和
     * @param courseGoalId
     * @param ncId
     * @return
     */
    Double getContributionSumOfNaturalClass(@Param("id") Integer courseGoalId, @Param("ncId") Integer ncId);
}
